MSSQL Database¶

version: 3.6
Compatibility: v 7.5.3
Requires: Host/IP/CIDR/CSV (Mandatory), Port (Mandatory), Username (Mandatory), Password (Mandatory), Instance Name (Mandatory), Enable Time Monitoring, Metric Collection Interval (Mandatory)
Operation: monitors the MSSQL Database.
Plugin-Metrics:

MSSQL Database¶

Metric	Data Type
Active Transactions	Numeric
Data File Size (KB)	Numeric
Log Flushed Bytes/sec	Numeric
Log File Size (KB)	Numeric
Log File Used Size (KB)	Numeric
Log Flush Waits/sec	Numeric
Log Utilization (%)	Numeric
Replication Transactions/sec	Numeric
Transactions/sec	Numeric
Log Cache Reads/sec	Numeric
Log Cache Hit Ratio (%)	Numeric
Bulk Copy Rows/sec	Numeric
Bulk Copy Throughput/sec	Numeric
Backup/Restore Throughput/sec	Numeric
DBCC Logical Scan Bytes/sec	Numeric
Shrink Data Movement Bytes/sec	Numeric
Log Flushes/sec	Numeric
Log Flush Wait Time (ms)	Numeric
Log Truncations	Numeric
Log Growths	Numeric
Log Shrinks	Numeric
Database Size (KB)	Numeric

Instance Columns:

Table

MSSQL Database Table¶